odate; /* $odate = $data->odate; $customer = $data->customer; $menus = $data->menus; $bko = $data->bkid; //$qty = $data->qty; //$ucost = $data->ucost; */ $ivid = inventid() ; $gettcost = $DBcon->prepare("select sum(totalcost) as tcost from invent_temporal") ; $gettcost->execute() ; $rwd = $gettcost->fetch(pdo::FETCH_ASSOC) ; $gc = $rwd['tcost'] ; $ins = $DBcon->prepare("insert into inventory_main(invent_id,gross_total,date_in,admin) values(:a,:b,NOW(),:c)") ; $ins->bindparam(":a",$ivid) ; $ins->bindparam(":b",$gc) ; $ins->bindparam(":c",$adm) ; if($ins->execute()) { $getall = $DBcon->prepare("select * from invent_temporal") ; $getall->execute() ; while($rd = $getall->fetch(pdo::FETCH_ASSOC)) { $comit = $DBcon->prepare("insert into invent_details(invent_id,item_category,item_name,qty,measure,totalpcs,nms,unit_cost,total_cost)values(:a,:b,:c,:d,:e,:f,:g,:h,:i)") ; $comit->bindparam(":a",$ivid) ; $comit->bindparam(":b",$rd['item_category']) ; $comit->bindparam(":c",$rd['item_name']) ; $comit->bindparam(":d",$rd['qty']) ; $comit->bindparam(":e",$rd['measure']) ; $comit->bindparam(":f",$rd['totalpcs']) ; $comit->bindparam(":g",$rd['no_in_ms']) ; $comit->bindparam(":h",$rd['unitcost']) ; $comit->bindparam(":i",$rd['totalcost']) ; if($comit->execute()) { $del = $DBcon->prepare("delete from invent_temporal") ; if($del->execute()) echo "INVENTORY COMMITED SUCCESSFUL TO DATABASE" ; } } } ?>